package JDBC;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class JDBCDemo11 {

    public static void main(String[] args) {
        try (Connection conn=DBUtil.getConnection();){
            conn.setAutoCommit(false);
            String sql="INSERT INTO userinfo(username,password,nickname,age) " +
                    "VALUES(?,?,?,?) ";


            PreparedStatement ps=conn.prepareStatement(sql);
            ps.setString(1,"王五");
            ps.setString(2,"123456");
            ps.setString(3,"小名");
            ps.setInt(4,18);

            int num= ps.executeUpdate();

            System.out.println(num>0?"添加成功":"添加失败");


//          conn.rollback();
//          System.out.println("事务回滚了");
            conn.commit();
            System.out.println("事务提交了");

        } catch (SQLException e) {
            throw new RuntimeException(e);
        }


    }
}
